Table Commands

February 20, 2023

Last updated on October 29, 2026

OneNote tables are quite simple, with really no functionality other than sorting by a single column. OneMore enhances table manageement with a set of commands that add flexibility, from formatting and auto-filling to powerful formulas and calculations.

Formulas and Calculations

For table formulas and calculations, see the Table Formulas and Calculations page.

───────────────────────────────────────────────────────────────────────────────────────────────────

General Table Commands

Convert Text to Table

Converts selected text to a table. Text must be delimited by a comma, space, or other special character so the command can detect columns.

Custom Sort

#Planned for future release, OneMore version 8.1.0

Sorts the rows of a table by one or more columns, each with its own direction and data type. Use it when the simple sort commands are not enough, for example to sort by Department and then by Salary within each department. The next time you open Custom Sort in the same table, the rules from your last sort are already filled in. Adjust them or click OK to sort again.

Format Cells

#Planned for future release, OneMore version 8.1.0

Applies Excel-style number, percent, currency, date and time formats to the values in a table. Use it to tidy values that were pasted or typed in raw, such as 1234.5, 0.25 or 2026-10-28, without retyping them. This can be used to format selected cells or entire columns.

Insert Table Cells

Adds the ability to insert cells into a table, shifting existing content down or to the right. This is similar to the Excel functionality with one enhancement - if you select a rectangular region of cells then it will shift just those cells, possibly overwriting other cells. If you select cells from one column or cells from one row then it will insert cells above or to the left and add rows or columns as needed to make room for the new cells.

Note that if you move cells with formulas, the cell references in those formulas are not updated automatically by this command; you'll need to adjust those manually.

Paste Table Cells

Paste copied cells into a table, overlaying cells rather than inserting a nested table as OneNote does by default. The target table is expanded with extra rows or columns as needed. All cell formatting, including cell shading, is preserved. This is useful for moving cells around within a table or copying cells from one table to another.

When copying cells with Ctrl-C and pasting back into the same table, the old cells are not erased. If your intention is to move the cells, leaving blank cells behind, then instead use Ctrl-X to copy and cut prior to running this paste command.

Note, you may notice the OneNote windows flashing once when this command is run. This is because OneMore needs to use a temporary page to do some of its work and you're seeing it navigate to that page and then back to your current page.

Select All Tables

Selects all tables so that you can then apply table themes or run other commands.

Split Table

Splits the current table starting at the row containing the input cursor. Optionally, the header can be duplicated in the new table

and columns in both can be fixed to their current widths so the two tables remain aligned.

Copy and Fill Commands

Copy Across, Copy Down

The Copy Across and Copy Down commands will duplicate the contents of the lead cells in the selection. For example, if you select one or more cells in the first row and choose Copy Down, the cell values, style, and shading in that row will be copied down the entire table. Restrict the scope by selecting the first cell to copy and subsequent cells to fill, either vertically or horizontally as appropriate.

Fill Across, Fill Down

The Fill Across and Fill Down commands will increment the values in the lead cells in the selection. For example, if the selected cell contains a number, that number will be incremented and added to all subsequent cells. If the second cell is populated then it will compare the second and first cell, determine the difference, and use that to increment the value. The Fill commands work for:

Numbers including integers, decimals, and currencies, incrementing by 1 or the integer difference of the first and second cell
Counting Strings such as "Person 1" will be incremented to populate "Person 2", "Person 3", "Person 4", etc.
Dates will be recognized and increment by adding 1 day or the difference in days between the first and second cell
- Date formats include these culture-specific formats (they change per culture)
  - M/d/YYYY
  - MMMM d
  - dddd, MMM d, yyyy
- And these explicit formats
  - d-MMM-yyyy
  - MMM d, yyyy
  - MMM d

#omwiki #omcommands

Please consider a sponsorship or one-time donation to support ongoing development

Created with OneNote.